/*    */ package com.qmsk.business.task.notes.dao;
/*    */ 
/*    */ import com.qmsk.business.sys.basic.SupportDAO;
/*    */ import com.utils.gson.out.GsonEbRst;
/*    */ import java.sql.SQLException;
/*    */ import java.util.HashMap;
/*    */ import java.util.Map;
/*    */ import org.springframework.stereotype.Repository;
/*    */ 
/*    */ @Repository
/*    */ public class NotesDao extends SupportDAO
/*    */ {
/*    */   public GsonEbRst getGsonOfShopId(Map<String, Object> params, Integer nPageIdx, Short nPageSize)
/*    */     throws SQLException
/*    */   {
/* 17 */     return getGsonOfParams("selectSqlOfShopId", "selectCountSqlOfShopId", 
/* 18 */       "selectJsonOfShopId", params, nPageIdx, nPageSize);
/*    */   }
/*    */ 
/*    */   public int updateCheckedOfIds(Long userId, String userName, String id) throws SQLException
/*    */   {
/* 23 */     Object[] strParams = { userId, userName };
/* 24 */     return update("updateCheckedOfIds", strParams);
/*    */   }
/*    */ 
/*    */   public int updatePraiseNums(Long id) throws SQLException {
/* 28 */     Object[] params = { id };
/* 29 */     return update("updatePraiseNums", params); }
/*    */ 
/*    */   public int updateNum(String id) throws SQLException {
/* 32 */     Object[] params = { id };
/* 33 */     return update("updateNum", params);
/*    */   }
/*    */ 
/*    */   public int updateStatus(Long id, Integer status) throws SQLException
/*    */   {
/* 38 */     Object[] params = { status, id };
/* 39 */     return update("updateStatus", params);
/*    */   }
/*    */ 
/*    */   public GsonEbRst getGsonOfAll(Map<String, Object> params, Integer nPageIdx, Short nPageSize) throws SQLException
/*    */   {
/* 44 */     return getGsonOfParams("selectSqlOfShopId", "selectCountSqlOfShopId", 
/* 45 */       "selectJsonOfShopId", params, nPageIdx, nPageSize);
/*    */   }
/*    */ 
/*    */   public GsonEbRst getGsonOfAll(Map<String, Object> params) throws SQLException {
/* 49 */     return getGsonOfParams("selectSqlOfShopId", 
/* 50 */       "selectJsonOfShopId", params);
/*    */   }
/*    */ 
/*    */   public int updateDiscussNum(Long noteId) throws SQLException {
/* 54 */     Object[] params = { noteId };
/* 55 */     return update("updateDiscussNum", params);
/*    */   }
/*    */ 
/*    */   public Integer checkExistbyMemberId(Long memberId, Long shopId) throws SQLException {
/* 59 */     Map params = new HashMap();
/* 60 */     params.put("memberId", memberId);
/* 61 */     params.put("shopId", shopId);
/* 62 */     return queryForInt("checkExistbyMemberId", params, Integer.valueOf(0));
/*    */   }
/*    */ }

/* Location:           C:\Users\Administrator\Desktop\新建文件夹\WEB-INF\classes\
 * Qualified Name:     com.qmsk.business.task.notes.dao.NotesDao
 * JD-Core Version:    0.5.3
 */